load data
truncate
into table CRST_PER_ALL_ASSIGNMENTS_F
fields terminated by "	"
trailing nullcols 
( ASSIGNMENT_ID                   ,
  EFFECTIVE_START_DATE            Date "YYYYMMDD HH24:MI:SS",
  EFFECTIVE_END_DATE              Date "YYYYMMDD HH24:MI:SS",
  BUSINESS_GROUP_ID               ,
  RECRUITER_ID                    ,
  GRADE_ID                        ,
  POSITION_ID                     ,
  JOB_ID                          ,
  ASSIGNMENT_STATUS_TYPE_ID       ,
  PAYROLL_ID                      ,
  LOCATION_ID                     ,
  PERSON_REFERRED_BY_ID           ,
  SUPERVISOR_ID                   ,
  SPECIAL_CEILING_STEP_ID         ,
  PERSON_ID                       ,
  RECRUITMENT_ACTIVITY_ID         ,
  SOURCE_ORGANIZATION_ID          ,
  ORGANIZATION_ID                 ,
  PEOPLE_GROUP_ID                 ,
  SOFT_CODING_KEYFLEX_ID          ,
  VACANCY_ID                      ,
  PAY_BASIS_ID                    ,
  ASSIGNMENT_SEQUENCE             ,
  ASSIGNMENT_TYPE                 ,
  PRIMARY_FLAG                    ,
  APPLICATION_ID                  ,
  ASSIGNMENT_NUMBER               ,
  CHANGE_REASON                   ,
  COMMENT_ID                      ,
  DATE_PROBATION_END              Date "YYYYMMDD HH24:MI:SS",
  DEFAULT_CODE_COMB_ID            ,
  EMPLOYMENT_CATEGORY             ,
  FREQUENCY                       ,
  INTERNAL_ADDRESS_LINE           ,
  MANAGER_FLAG                    ,
  NORMAL_HOURS                    ,
  PERF_REVIEW_PERIOD              ,
  PERF_REVIEW_PERIOD_FREQUENCY    ,
  PERIOD_OF_SERVICE_ID            ,
  PROBATION_PERIOD                ,
  PROBATION_UNIT                  ,
  SAL_REVIEW_PERIOD               ,
  SAL_REVIEW_PERIOD_FREQUENCY     ,
  SET_OF_BOOKS_ID                 ,
  SOURCE_TYPE                     ,
  TIME_NORMAL_FINISH              ,
  TIME_NORMAL_START               ,
  REQUEST_ID                      ,
  PROGRAM_APPLICATION_ID          ,
  PROGRAM_ID                      ,
  PROGRAM_UPDATE_DATE             Date "YYYYMMDD HH24:MI:SS",
  ASS_ATTRIBUTE_CATEGORY          ,
  ASS_ATTRIBUTE1                  ,
  ASS_ATTRIBUTE2                  ,
  ASS_ATTRIBUTE3                  ,
  ASS_ATTRIBUTE4                  ,
  ASS_ATTRIBUTE5                  ,
  ASS_ATTRIBUTE6                  ,
  ASS_ATTRIBUTE7                  ,
  ASS_ATTRIBUTE8                  ,
  ASS_ATTRIBUTE9                  ,
  ASS_ATTRIBUTE10                 ,
  ASS_ATTRIBUTE11                 ,
  ASS_ATTRIBUTE12                 ,
  ASS_ATTRIBUTE13                 ,
  ASS_ATTRIBUTE14                 ,
  ASS_ATTRIBUTE15                 ,
  ASS_ATTRIBUTE16                 ,
  ASS_ATTRIBUTE17                 ,
  ASS_ATTRIBUTE18                 ,
  ASS_ATTRIBUTE19                 ,
  ASS_ATTRIBUTE20                 ,
  ASS_ATTRIBUTE21                 ,
  ASS_ATTRIBUTE22                 ,
  ASS_ATTRIBUTE23                 ,
  ASS_ATTRIBUTE24                 ,
  ASS_ATTRIBUTE25                 ,
  ASS_ATTRIBUTE26                 ,
  ASS_ATTRIBUTE27                 ,
  ASS_ATTRIBUTE28                 ,
  ASS_ATTRIBUTE29                 ,
  ASS_ATTRIBUTE30                 ,
  LAST_UPDATE_DATE                Date "YYYYMMDD HH24:MI:SS",
  LAST_UPDATED_BY                 ,
  LAST_UPDATE_LOGIN               ,
  CREATED_BY                      ,
  CREATION_DATE                   Date "YYYYMMDD HH24:MI:SS",
  TITLE                           ,
  OBJECT_VERSION_NUMBER           ,
  BARGAINING_UNIT_CODE            ,
  LABOUR_UNION_MEMBER_FLAG        ,
  HOURLY_SALARIED_CODE            ,
  CONTRACT_ID                     ,
  COLLECTIVE_AGREEMENT_ID         ,
  CAGR_ID_FLEX_NUM                ,
  CAGR_GRADE_DEF_ID               ,
  ESTABLISHMENT_ID                ,
  NOTICE_PERIOD                   ,
  NOTICE_PERIOD_UOM               ,
  EMPLOYEE_CATEGORY               ,
  WORK_AT_HOME                    ,
  JOB_POST_SOURCE_NAME            ,
  POSTING_CONTENT_ID              ,
  PERIOD_OF_PLACEMENT_DATE_START  Date "YYYYMMDD HH24:MI:SS",
  VENDOR_ID                       ,
  VENDOR_EMPLOYEE_NUMBER          ,
  VENDOR_ASSIGNMENT_NUMBER        ,
  ASSIGNMENT_CATEGORY             ,
  PROJECT_TITLE                   ,
  APPLICANT_RANK 
)